Tabela TreatmentSteps

Definicja tabeli TreatmentSteps

Name

TreatmentSteps

Code

TreatmentSteps

Comment

Tabela slownikowa zawierajaca etapy leczenia w postaci Protokol->Grupa->Etap.


Lista kolumn tabeli TreatmentSteps

Name

Code

TreatmentStepsID

TreatmentStepsID

TreatmentStepsTypeID

TreatmentStepsTypeID

RootID

RootID

ParentID

ParentID

Code

Code

ShortName

ShortName

FullName

FullName

Description

Description

StepOrder

StepOrder

StartDT

StartDT

StopDT

StopDT

Active

Active


Kolumna TreatmentStepsID tabeli TreatmentSteps

Definicja kolumny TreatmentStepsID tabeli TreatmentSteps

Name

TreatmentStepsID

Code

TreatmentStepsID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TreatmentStepsTypeID tabeli TreatmentSteps

Definicja kolumny TreatmentStepsTypeID tabeli TreatmentSteps

Name

TreatmentStepsTypeID

Code

TreatmentStepsTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna RootID tabeli TreatmentSteps

Definicja kolumny RootID tabeli TreatmentSteps

Name

RootID

Code

RootID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ParentID tabeli TreatmentSteps

Definicja kolumny ParentID tabeli TreatmentSteps

Name

ParentID

Code

ParentID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Code tabeli TreatmentSteps

Definicja kolumny Code tabeli TreatmentSteps

Name

Code

Code

Code

Data Type

VARCHAR2(10)

Mandatory

Yes

Comment

 


Kolumna ShortName tabeli TreatmentSteps

Definicja kolumny ShortName tabeli TreatmentSteps

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

Yes

Comment

 


Kolumna FullName tabeli TreatmentSteps

Definicja kolumny FullName tabeli TreatmentSteps

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna Description tabeli TreatmentSteps

Definicja kolumny Description tabeli TreatmentSteps

Name

Description

Code

Description

Data Type

VARCHAR2(765)

Mandatory

No

Comment

 


Kolumna StepOrder tabeli TreatmentSteps

Definicja kolumny StepOrder tabeli TreatmentSteps

Name

StepOrder

Code

StepOrder

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli TreatmentSteps

Definicja kolumny StartDT tabeli TreatmentSteps

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna StopDT tabeli TreatmentSteps

Definicja kolumny StopDT tabeli TreatmentSteps

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Active tabeli TreatmentSteps

Definicja kolumny Active tabeli TreatmentSteps

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Lista kluczy tabeli TreatmentSteps

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TreatmentSteps

Definicja klucza Identifier_1 tabeli TreatmentSteps

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment